package com.hrp.hrpdao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.mapping.StatementType;

import java.util.List;
import java.util.Map;

/**
 * Created by Administrator on 2019/5/3 0003.
 */
@Mapper
public interface ExcelExportDao {

    @Options(statementType= StatementType.CALLABLE)
    @Select({ "exec usp_uimms_getTransportRecordByPageForProc_excelExport #{page},#{rows},#{sort},#{order},#{sendTimeKsrq},#{sendTimeJsrq},#{varietiesIdStr},#{supplierIdStr},#{receiverIdStr}" })
    List<Map<String,Object>> getTransportRecordByPageForProc(Map<String,String> params);

    @Options(statementType= StatementType.CALLABLE)
    @Select({ "exec usp_uimms_getTransportRecordForProc_Summary_exceExport #{sort},#{order},#{sendTimeKsrq},#{sendTimeJsrq},#{varietiesIdStr},#{supplierIdStr},#{receiverIdStr}" })
    List<Map<String,Object>> getTransportRecordSummaryForProc(Map<String, String> params);
}
